/*
 Navicat Premium Data Transfer

 Source Server         : my
 Source Server Type    : MySQL
 Source Server Version : 80032 (8.0.32)
 Source Host           : localhost:3306
 Source Schema         : mkyjy

 Target Server Type    : MySQL
 Target Server Version : 80032 (8.0.32)
 File Encoding         : 65001

 Date: 06/01/2025 13:55:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `createTime` datetime DEFAULT NULL,
  `parentId` int NOT NULL,
  `state` int NOT NULL,
  `text` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for choice_question
-- ----------------------------
DROP TABLE IF EXISTS `choice_question`;
CREATE TABLE `choice_question` (
  `id` int NOT NULL AUTO_INCREMENT,
  `answer` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `nanduxishu` int DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `titleABCD` varchar(255) DEFAULT NULL,
  `titleType` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of choice_question
-- ----------------------------
BEGIN;
INSERT INTO `choice_question` (`id`, `answer`, `createTime`, `nanduxishu`, `pid`, `remarks`, `status`, `title`, `titleABCD`, `titleType`) VALUES (1, 'C', '2023-07-16 08:38:22', 1, 5, NULL, 1, '', '{\"A\":\"\",\"B\":\"\",\"C\":\"\",\"D\":\"\"}', 1);
INSERT INTO `choice_question` (`id`, `answer`, `createTime`, `nanduxishu`, `pid`, `remarks`, `status`, `title`, `titleABCD`, `titleType`) VALUES (2, 'A', '2023-07-16 08:39:12', 1, 5, NULL, 1, '<p>432432423</p>\n', '{\"A\":\"<p>432432432</p>\\n\",\"B\":\"<p>4324324</p>\\n\",\"C\":\"<p>4324324</p>\\n\",\"D\":\"<p>432432423</p>\\n\"}', 1);
INSERT INTO `choice_question` (`id`, `answer`, `createTime`, `nanduxishu`, `pid`, `remarks`, `status`, `title`, `titleABCD`, `titleType`) VALUES (3, 'A,B,C', '2023-07-16 08:55:42', 1, 5, NULL, 1, '<p>大数据处理流程可以概括为以下哪几步？（&nbsp; &nbsp;）</p>\n', '{\"A\":\"<p>统计和分析</p>\\n\",\"B\":\"<p>挖掘</p>\\n\",\"C\":\"<p>导入和处理</p>\\n\",\"D\":\"<p>查看</p>\\n\"}', 2);
COMMIT;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contactsPhone` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `deviceId` int NOT NULL,
  `head` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `passTime` datetime DEFAULT NULL,
  `state` int DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device
-- ----------------------------
DROP TABLE IF EXISTS `device`;
CREATE TABLE `device` (
  `id` int NOT NULL AUTO_INCREMENT,
  `brands` varchar(255) DEFAULT NULL,
  `categoryId` int NOT NULL,
  `contacts` varchar(255) DEFAULT NULL,
  `contactsPhone` varchar(255) DEFAULT NULL,
  `deposit` decimal(19,2) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `hot` int DEFAULT NULL,
  `month` decimal(19,2) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `once` decimal(19,2) DEFAULT NULL,
  `price` decimal(19,2) DEFAULT NULL,
  `situation` int NOT NULL,
  `state` int DEFAULT NULL,
  `tonnage` int DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `year` decimal(19,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of device
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for file_depot
-- ----------------------------
DROP TABLE IF EXISTS `file_depot`;
CREATE TABLE `file_depot` (
  `id` int NOT NULL AUTO_INCREMENT,
  `author` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `fileName` varchar(255) DEFAULT NULL,
  `fileSize` varchar(255) DEFAULT NULL,
  `fileZip` tinyblob,
  `state` int DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `titleType` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of file_depot
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for file_manage
-- ----------------------------
DROP TABLE IF EXISTS `file_manage`;
CREATE TABLE `file_manage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `createTime` datetime DEFAULT NULL,
  `deviceId` int DEFAULT NULL,
  `fileName` varchar(255) DEFAULT NULL,
  `fileOldName` varchar(255) DEFAULT NULL,
  `fileType` int NOT NULL,
  `message` varchar(255) DEFAULT NULL,
  `sort` int NOT NULL,
  `state` int DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKpkcpjlti8l428ubrmx3axnkq9` (`deviceId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of file_manage
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for information
-- ----------------------------
DROP TABLE IF EXISTS `information`;
CREATE TABLE `information` (
  `id` int NOT NULL AUTO_INCREMENT,
  `detail` varchar(255) DEFAULT NULL,
  `hot` int DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `state` int NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` int NOT NULL,
  `updateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of information
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for paper_two
-- ----------------------------
DROP TABLE IF EXISTS `paper_two`;
CREATE TABLE `paper_two` (
  `id` int NOT NULL AUTO_INCREMENT,
  `answer` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `nanduxishu` int DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `titleType` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of paper_two
-- ----------------------------
BEGIN;
INSERT INTO `paper_two` (`id`, `answer`, `createTime`, `nanduxishu`, `pid`, `remarks`, `status`, `title`, `titleType`) VALUES (1, '{\"1\":\"kafka\",\"2\":\"Sqoop\",\"3\":\"Flume\"}', '2023-07-16 09:01:36', 1, 5, NULL, 1, '<p>常用的大数据采集工具包括___________、______________、______________</p>\n', 2);
COMMIT;

-- ----------------------------
-- Table structure for radio_depot
-- ----------------------------
DROP TABLE IF EXISTS `radio_depot`;
CREATE TABLE `radio_depot` (
  `id` int NOT NULL AUTO_INCREMENT,
  `answer` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `optionA` varchar(255) DEFAULT NULL,
  `optionB` varchar(255) DEFAULT NULL,
  `optionC` varchar(255) DEFAULT NULL,
  `optionD` varchar(255) DEFAULT NULL,
  `state` int DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of radio_depot
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for structure
-- ----------------------------
DROP TABLE IF EXISTS `structure`;
CREATE TABLE `structure` (
  `id` int NOT NULL AUTO_INCREMENT,
  `createTime` datetime DEFAULT NULL,
  `fid` int DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of structure
-- ----------------------------
BEGIN;
INSERT INTO `structure` (`id`, `createTime`, `fid`, `remarks`, `state`, `status`, `text`) VALUES (3, '2023-07-16 08:34:40', 2, NULL, 'open', 1, '网络专业');
INSERT INTO `structure` (`id`, `createTime`, `fid`, `remarks`, `state`, `status`, `text`) VALUES (2, '2023-07-16 08:33:06', 0, NULL, 'open', 1, '计算机系');
INSERT INTO `structure` (`id`, `createTime`, `fid`, `remarks`, `state`, `status`, `text`) VALUES (4, '2023-07-16 08:34:51', 2, NULL, 'open', 1, '软件专业');
INSERT INTO `structure` (`id`, `createTime`, `fid`, `remarks`, `state`, `status`, `text`) VALUES (5, '2023-07-16 08:35:06', 2, NULL, 'open', 1, '大数据专业');
INSERT INTO `structure` (`id`, `createTime`, `fid`, `remarks`, `state`, `status`, `text`) VALUES (6, '2023-07-16 08:48:49', 0, NULL, 'open', 1, '旅游管理系');
COMMIT;

-- ----------------------------
-- Table structure for student_information
-- ----------------------------
DROP TABLE IF EXISTS `student_information`;
CREATE TABLE `student_information` (
  `id` bigint NOT NULL,
  `createTime` datetime DEFAULT NULL,
  `headSculpture` varchar(255) DEFAULT NULL,
  `kaohao` varchar(255) DEFAULT NULL,
  `lastloginTime` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `pid` bigint DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `sfz` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of student_information
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_course
-- ----------------------------
DROP TABLE IF EXISTS `sys_course`;
CREATE TABLE `sys_course` (
  `id` int NOT NULL AUTO_INCREMENT,
  `courseAuthor` varchar(255) DEFAULT NULL,
  `courseCover` varchar(255) DEFAULT NULL,
  `courseGrade` int DEFAULT NULL,
  `courseIntroduce` varchar(255) DEFAULT NULL,
  `courseName` varchar(255) DEFAULT NULL,
  `createAdmin` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `status` int DEFAULT NULL,
  `subjectID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sys_course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_subject
-- ----------------------------
DROP TABLE IF EXISTS `sys_subject`;
CREATE TABLE `sys_subject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `createAdmin` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `fid` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `subjectMsg` varchar(255) DEFAULT NULL,
  `subjectName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sys_subject
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_video_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_video_file`;
CREATE TABLE `sys_video_file` (
  `id` int NOT NULL AUTO_INCREMENT,
  `chapterChapter` varchar(255) DEFAULT NULL,
  `chapterCoursewarePath` varchar(255) DEFAULT NULL,
  `chapterDescribe` varchar(255) DEFAULT NULL,
  `chapterVideoPath` varchar(255) DEFAULT NULL,
  `couresID` int DEFAULT NULL,
  `createAdmin` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `fileSize` bigint DEFAULT NULL,
  `fileType` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sys_video_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_vmware_pm
-- ----------------------------
DROP TABLE IF EXISTS `sys_vmware_pm`;
CREATE TABLE `sys_vmware_pm` (
  `id` int NOT NULL AUTO_INCREMENT,
  `createAdmin` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `status` int DEFAULT NULL,
  `sysAttribute` varchar(255) DEFAULT NULL,
  `sysConfigure` varchar(255) DEFAULT NULL,
  `sysEdition` varchar(255) DEFAULT NULL,
  `sysIP` varchar(255) DEFAULT NULL,
  `sysOSE` varchar(255) DEFAULT NULL,
  `sysOther` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sys_vmware_pm
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `avatar` varchar(255) DEFAULT NULL,
  `createTime` varchar(255) DEFAULT NULL,
  `creatorId` varchar(255) DEFAULT NULL,
  `deleted` varchar(255) DEFAULT NULL,
  `lastLoginIp` varchar(255) DEFAULT NULL,
  `lastLoginTime` datetime DEFAULT NULL,
  `merchantCode` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `roleId` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
BEGIN;
INSERT INTO `userinfo` (`id`, `avatar`, `createTime`, `creatorId`, `deleted`, `lastLoginIp`, `lastLoginTime`, `merchantCode`, `name`, `password`, `role`, `roleId`, `status`, `telephone`, `username`) VALUES (1, NULL, NULL, NULL, NULL, NULL, '2025-01-06 13:48:42', NULL, 'admin', '$2a$10$33tQucEwVKeJ/MC7ODRmNONiIOA76D4Vj6ddjgUb882tMPTO3y87a', '1', '1', 1, NULL, 'admin');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
